require 'sqlite3'

db =SQLite3::Database.new( "test.db" )
rows = db.execute( "
CREATE TABLE fruit_prices
(
P_Id integer not null primary key,
fruit text unique,
price real,
)
INSERT INTO fruit_prices
VALUES (1, 'bananas', 0.34)

INSERT INTO fruit_prices
VALUES (2, 'apples', 0.52)

INSERT INTO fruit_prices
VALUES (3, 'strawberries', 1.25)
" )